<?xml version="1.0" encoding="UTF-8" ?>
<sqlMap namespace="LineItem" 
xmlns="http://ibatis.apache.org/mapping" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
	<statements>
	<select id="Com.Pirate.Domain.Objects.userinfo_SELECT_Default" resultMap="userinfo_Mapper" resultClass="Com.Pirate.Domain.Objects.userinfo" parameterClass="Com.Pirate.Domain.Objects.userinfo">
		SELECT * FROM userinfo
	</select>
	<insert id="Com.Pirate.Domain.Objects.userinfo_INSERT_Default" parameterClass="Com.Pirate.Domain.Objects.userinfo">
		INSERT into userinfo (FamilyName,FirstName,Id,SecondName) values(#DB_FamilyName#,#DB_FirstName#,#DB_Id#,#DB_SecondName#)
	</insert>
	<update id="Com.Pirate.Domain.Objects.userinfo_UPDATE_Default" parameterClass="Com.Pirate.Domain.Objects.userinfo">
    UPDATE userinfo set FamilyName=#DB_FamilyName#,FirstName=#DB_FirstName#,SecondName=#DB_SecondName# where Id=#DB_Id#
  </update>
	<delete id="Com.Pirate.Domain.Objects.userinfo_DELETE_Default" parameterClass="Com.Pirate.Domain.Objects.userinfo">
    DELETE FROM userinfo where Id=#DB_Id#
  </delete>
	</statements>
</sqlMap>
